/*
 * TestDriver2.java
 *
 * Created on November 29, 2007, 3:55 PM
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package edu.drivers;

import edu.sql.OracleConnector;
import java.util.Iterator;
import java.util.List;

/**
 *
 * @author joseacuna-rohter
 */
public class TestDriver2 {
    
    /** Creates a new instance of TestDriver2 */
    public TestDriver2() {
    }
    
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        Iterator rIt; 
        OracleConnector oc = new OracleConnector();    
        List resultList;
        
        resultList = oc.Select("EMPLOYEE",2);
        
        rIt = resultList.iterator();
        while(rIt.hasNext())
            System.out.println(rIt.next().toString());
        
        
        oc.SelectRS("EMPLOYEE");
        
        oc.Execute("INSERT INTO EMPLOYEE (employeeNum,lastName,firstName,dateOfBirth,address,phone,degree,yearsExperience,startSalary,currentSalary,primaryDepartmentName,FT_PT ) VALUES ( 99,'Schroeder','Ashley','07-Jan-1986','5868 N. Lacey Ave. Chicago IL, 60646',3124795456,'BS',2,59000,67000,'IT','FT')");
        oc.Execute("Commit");
        
    }
    
}
